The Role
Hands-on ETL lead responsible for Informatica PowerCenter ETL development and optimization, Teradata scripting and load utilities, architectural design and data modeling, data profiling and data quality rule implementation, change management, stakeholder reporting, version control, and managing global delivery for large-scale maintenance and deployments.
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
- Informatica PowerCenter 8.6 or higher experience
- Development of complex Informatica ETL jobs and transformations
- Informatica partitioning and push-down optimization
- Experience with Informatica tasks (Session, Email, Command)
- Processing sources: flat files, Oracle, XML
- SCD2 and SCD3 implementation
- Teradata BTEQ scripts development
- Teradata load utilities: FastLoad, MultiLoad, TRUMP, FastExport
- Build Teradata objects: tables, views, macros, stored procedures, triggers
- Teradata performance tuning and collecting statistics
- Experience with large-scale maintenance projects, impact analysis, code modifications and deployment
- Hands-on technical contributor
- Change management experience
- Architectural design and data modeling experience
- Writing and validating data quality rules
- Data profiling experience
- Work with multiple stakeholders and provide status reporting to clients/stakeholders
- Manage global delivery structure
- Implement ETL best practices and adhere to process framework
- Experience with version control tools and code comparison approaches
- Bachelor's degree (or equivalent experience substitution)
- At least 4 years of experience with Java technologies
- Exposure/knowledge of MDM
- Authorization to work in the U.S. without sponsorship (US Citizen, Green Card, GC-EAD, H4-EAD, L2-EAD, TN Visa)
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.
