At Softrams, LLC we take pride in building & delivering human centered usable digital services for our users and stakeholders. We build small self-reliant teams and empower them to design, develop and deliver products with emphasizing end to end user experience.
ETL Developer Responsibilities:
Perform design, development, unit test, document and support of complex data extract transformation and load (ETL) programs, using Informatica Power Center as well as knowledge of data warehousing and data mart architectures, concepts and processes
Improve existing data designs and design new databases and data models, including relational table structures, using Unix Shell Scripting, DB2 and Teradata
Read and translate logical data models and use ETL skills to load the physical layer, based on an understanding of timing of data loads, data transformation, and optimization of ETL load performance.
Provide production support and test approaches for data management projects
Work closely between Architects, Testers and Business resources on efforts of various scope
Participate in all phases of the systems development life cycle, including requirements analysis, design (including code design and code reviews), development, testing and deployment.
5 yrs experience developing, maintaining and supporting ETL programs with various target/source types and ETL transformations
3 yrs experience in data warehouse (with large datasets) and business intelligence environment working on the implementation of an enterprise data management processes, procedures, and decision support using Informatica Power Center v10.x
3 yrs experience using Informatica Power Center v10.x
3 yrs experience using Unix Shell Scripting and developing DB2 stored procedures
Experience with AWS, Cloudera Data Lake, SnowFlake cloud is highly desired
Experience with data modeling and data mapping design.
Excellent troubleshooting and problem-solving skills.
Softrams is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, nation origin, sexual orientation, gender identity, disability or protected veteran status.
As a HUBZone certified business, we strongly encourage candidates who reside in a HUBZone area to apply. Click on the link here to check if you are in the HubZone area (http://map.sba.gov/hubzone/maps/).