The Role
Lead hands-on development and enhancement of complex Informatica PowerCenter ETL jobs, implement SCD2/SCD3, optimize transformations and partitioning, build and tune Teradata objects and load utilities, perform data profiling and quality rule validation, manage change, stakeholders and global delivery, follow process frameworks and version control, and implement ETL best practices.
Summary Generated by Built In
Company Description
Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
- Extensive 8.6 or Higher Version- Informatica PowerCenter Technical Experience
- Experience in Informatica Complex ETL jobs Development
- Experience in Informatica Complex Transformations, Partitioning, PushDown Optimization
- Experience in Informatica Tasks - Session, email, Command, etc
- Experience in Informatica Experience in Processing various sources including flat files, Oracle, XML,etc
- Experience in Informatica - SCD2, SCD3 Implementation
- Experience in Teradata - BTEQ Scripts Development
- Experience in Teradata Load Utilities - FastLoad, MultiLoad, TRUMP,FastExport
- Experience in building Teradata Objects: Tables, views, macros, stored procedures and triggers
- Experience in Teradata Performance Tuning - Debugging the Job, Collect Stats Experience in large scale Maintenance Projects that involves extensive Impact Analysis, Code Modifications and Deployment
- Exposure/Knowledge on MDM
- We need someone who is HANDS-ON
- Change Management
- Architectural Design and Data Modelling Experience
- Experience in Writing and validating Data Quality rules against Data
- Experience in Data Profiling
- Work with multiple stakeholders
- Manage Global Delivery structure
- Status Reporting Periodic to Clients/Stakeholders
- Experience in Implementing Best Practices of ETL Projects
- Experience in following and adhering to Process Framework
- Experience in Version Control Tools, Code Comparison approaches.
- Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
- At least 4 years of experience with Java technologies.
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a FULL TIME job oppurtunity.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, TN VIsa can apply.
- No H1-B & OPT is applicable for this position.
- Please mention your email id in your email or resume.
Skills Required
- Extensive Informatica PowerCenter (8.6+) experience
- Complex ETL job development and complex transformations
- Partitioning and PushDown Optimization experience
- Experience with Informatica tasks (Session, Email, Command)
- Experience processing sources including flat files, Oracle, XML
- SCD2 and SCD3 implementation experience
- Teradata BTEQ scripts development
- Experience with Teradata load utilities: FastLoad, MultiLoad, TPUMP, FastExport
- Building Teradata objects (tables, views, macros, stored procedures, triggers)
- Teradata performance tuning and collect statistics
- Experience in large scale maintenance projects including impact analysis, code modifications and deployment
- Hands-on role (practical implementation)
- Change management experience
- Architectural design and data modeling experience
- Writing and validating data quality rules
- Data profiling experience
- Experience working with multiple stakeholders and status reporting to clients
- Manage global delivery structure
- Implementing ETL best practices and adhering to process frameworks
- Experience with version control tools and code comparison approaches
- Bachelor's degree or equivalent experience
- At least 4 years of experience with Java technologies
- Exposure/knowledge of MDM
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.
